How to split the full name into FirstName and LastName in SQL server?

Question

Ashutosh Kumar Verma · Answer

To split a FullName into FirstName and LastName in SQL Server, you can use string functions like CHARINDEX, LEFT and RIGHT. Here is an example of how you can do this,
Assuming you have an SQL table Employees with a column EmpName that contains the name in the format of “FirstName and LastName”,
Here is the SQL Query to split the full name into first name and lastname
SELECT EmpName, LEFT(EmpName, CHARINDEX(' ', EmpName) - 1) AS FirstName,
   RIGHT(EmpName, LEN(EmpName) - CHARINDEX(' ', EmpName)) AS LastName
FROM Employees
and Example-
and

interview

How to split the full name into FirstName and LastName in SQL server?

Ashutosh Kumar Verma

Can you answer this question?

1 Answers

Liked By